Dataset statistics
| Number of variables | 26 |
|---|---|
| Number of observations | 179 |
| Missing cells | 25 |
| Missing cells (%) | 0.5% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 36.5 KiB |
| Average record size in memory | 208.7 B |
Variable types
| NUM | 21 |
|---|---|
| CAT | 3 |
| BOOL | 2 |
Num_calls_Cuscare has constant value "179" | Constant |
Num_of_payments is highly correlated with Total_Bills | High correlation |
Total_Bills is highly correlated with Num_of_payments | High correlation |
Mean_Mthly_Paid_last6mth is highly correlated with Mean_Mthly_Paid and 1 other fields | High correlation |
Mean_Mthly_Paid is highly correlated with Mean_Mthly_Paid_last6mth | High correlation |
Total_Paid_last6mth is highly correlated with Mean_Mthly_Paid_last6mth | High correlation |
Num_Payments_last6mth is highly correlated with Total_Bills_last6mth and 1 other fields | High correlation |
Total_Bills_last6mth is highly correlated with Num_Payments_last6mth and 1 other fields | High correlation |
Delayed_Partial_Payments_last6mth is highly correlated with Total_Bills_last6mth and 1 other fields | High correlation |
avg_Data_last6mth is highly correlated with avg_Data | High correlation |
avg_Data is highly correlated with avg_Data_last6mth | High correlation |
Age has 9 (5.0%) missing values | Missing |
LocID has 3 (1.7%) missing values | Missing |
Mean_Mthly_Paid has 2 (1.1%) missing values | Missing |
Mean_Mthly_Paid_last6mth has 3 (1.7%) missing values | Missing |
ttl_Data has 2 (1.1%) missing values | Missing |
Cust_id has unique values | Unique |
avg_Data_last6mth has unique values | Unique |
avg_online_days has unique values | Unique |
Timely_full_payments has 4 (2.2%) zeros | Zeros |
Timely_Full_Payments_last6mth has 7 (3.9%) zeros | Zeros |
Delayed_Partial_Payments_last6mth has 61 (34.1%) zeros | Zeros |
Reproduction
| Analysis started | 2021-01-20 06:33:29.649982 |
|---|---|
| Analysis finished | 2021-01-20 06:36:05.182388 |
| Duration | 2 minutes and 35.53 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
| Distinct | 179 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 90 |
|---|---|
| Minimum | 1 |
| Maximum | 179 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 9.9 |
| Q1 | 45.5 |
| median | 90 |
| Q3 | 134.5 |
| 95-th percentile | 170.1 |
| Maximum | 179 |
| Range | 178 |
| Interquartile range (IQR) | 89 |
Descriptive statistics
| Standard deviation | 51.81698563 |
|---|---|
| Coefficient of variation (CV) | 0.5757442848 |
| Kurtosis | -1.2 |
| Mean | 90 |
| Median Absolute Deviation (MAD) | 45 |
| Skewness | 0 |
| Sum | 16110 |
| Variance | 2685 |
| Monotocity | Strictly increasing |
| Value | Count | Frequency (%) | |
| 1 | 1 | 0.6% | |
| 135 | 1 | 0.6% | |
| 115 | 1 | 0.6% | |
| 116 | 1 | 0.6% | |
| 117 | 1 | 0.6% | |
| 118 | 1 | 0.6% | |
| 119 | 1 | 0.6% | |
| 120 | 1 | 0.6% | |
| 121 | 1 | 0.6% | |
| 122 | 1 | 0.6% | |
| Other values (169) | 169 | 94.4% |
| Value | Count | Frequency (%) | |
| 1 | 1 | 0.6% | |
| 2 | 1 | 0.6% | |
| 3 | 1 | 0.6% | |
| 4 | 1 | 0.6% | |
| 5 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 179 | 1 | 0.6% | |
| 178 | 1 | 0.6% | |
| 177 | 1 | 0.6% | |
| 176 | 1 | 0.6% | |
| 175 | 1 | 0.6% |
| Distinct | 43 |
|---|---|
| Distinct (%) | 25.3% |
| Missing | 9 |
| Missing (%) | 5.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 36.50588235 |
|---|---|
| Minimum | 19 |
| Maximum | 75 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 19 |
|---|---|
| 5-th percentile | 20.45 |
| Q1 | 26 |
| median | 33 |
| Q3 | 46 |
| 95-th percentile | 58 |
| Maximum | 75 |
| Range | 56 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 12.98713385 |
|---|---|
| Coefficient of variation (CV) | 0.3557545528 |
| Kurtosis | -0.08207201354 |
| Mean | 36.50588235 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | 0.7383578214 |
| Sum | 6206 |
| Variance | 168.6656457 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 24 | 8 | 4.5% | |
| 32 | 8 | 4.5% | |
| 26 | 8 | 4.5% | |
| 21 | 8 | 4.5% | |
| 38 | 7 | 3.9% | |
| 48 | 7 | 3.9% | |
| 27 | 7 | 3.9% | |
| 20 | 7 | 3.9% | |
| 25 | 6 | 3.4% | |
| 46 | 6 | 3.4% | |
| Other values (33) | 98 | 54.7% | |
| (Missing) | 9 | 5.0% |
| Value | Count | Frequency (%) | |
| 19 | 2 | 1.1% | |
| 20 | 7 | 3.9% | |
| 21 | 8 | 4.5% | |
| 22 | 5 | 2.8% | |
| 23 | 5 | 2.8% |
| Value | Count | Frequency (%) | |
| 75 | 1 | 0.6% | |
| 73 | 1 | 0.6% | |
| 70 | 2 | 1.1% | |
| 69 | 1 | 0.6% | |
| 67 | 1 | 0.6% |
| Distinct | 14 |
|---|---|
| Distinct (%) | 8.0% |
| Missing | 3 |
| Missing (%) | 1.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 237.7215909 |
|---|---|
| Minimum | 231 |
| Maximum | 265 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 231 |
|---|---|
| 5-th percentile | 231 |
| Q1 | 232 |
| median | 237 |
| Q3 | 240 |
| 95-th percentile | 249.25 |
| Maximum | 265 |
| Range | 34 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 7.515833935 |
|---|---|
| Coefficient of variation (CV) | 0.03161611828 |
| Kurtosis | 6.391939252 |
| Mean | 237.7215909 |
| Median Absolute Deviation (MAD) | 4.5 |
| Skewness | 2.349974308 |
| Sum | 41839 |
| Variance | 56.48775974 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 231 | 34 | 19.0% | |
| 238 | 24 | 13.4% | |
| 242 | 20 | 11.2% | |
| 232 | 15 | 8.4% | |
| 237 | 15 | 8.4% | |
| 236 | 15 | 8.4% | |
| 244 | 10 | 5.6% | |
| 235 | 9 | 5.0% | |
| 265 | 9 | 5.0% | |
| 234 | 9 | 5.0% | |
| Other values (4) | 16 | 8.9% |
| Value | Count | Frequency (%) | |
| 231 | 34 | 19.0% | |
| 232 | 15 | 8.4% | |
| 233 | 4 | 2.2% | |
| 234 | 9 | 5.0% | |
| 235 | 9 | 5.0% |
| Value | Count | Frequency (%) | |
| 265 | 9 | 5.0% | |
| 244 | 10 | 5.6% | |
| 242 | 20 | 11.2% | |
| 241 | 2 | 1.1% | |
| 240 | 8 | 4.5% |
GenID
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 KiB |
| 1 | |
|---|---|
| 2 |
| Value | Count | Frequency (%) | |
| 1 | 101 | 56.4% | |
| 2 | 78 | 43.6% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
RaceID
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | 2.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 KiB |
| 1 | |
|---|---|
| 2 | |
| 3 | |
| 4 |
| Value | Count | Frequency (%) | |
| 1 | 100 | 55.9% | |
| 2 | 50 | 27.9% | |
| 3 | 15 | 8.4% | |
| 4 | 14 | 7.8% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
PkgID
Real number (ℝ≥0)
| Distinct | 34 |
|---|---|
| Distinct (%) | 19.1% |
| Missing | 1 |
| Missing (%) | 0.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 123.5674157 |
|---|---|
| Minimum | 1 |
| Maximum | 273 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 10 |
| median | 197 |
| Q3 | 227 |
| 95-th percentile | 227 |
| Maximum | 273 |
| Range | 272 |
| Interquartile range (IQR) | 217 |
Descriptive statistics
| Standard deviation | 101.1814305 |
|---|---|
| Coefficient of variation (CV) | 0.8188358546 |
| Kurtosis | -1.900285423 |
| Mean | 123.5674157 |
| Median Absolute Deviation (MAD) | 57 |
| Skewness | -0.08845522706 |
| Sum | 21995 |
| Variance | 10237.68187 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 227 | 53 | 29.6% | |
| 197 | 23 | 12.8% | |
| 10 | 19 | 10.6% | |
| 9 | 15 | 8.4% | |
| 6 | 6 | 3.4% | |
| 11 | 6 | 3.4% | |
| 14 | 5 | 2.8% | |
| 89 | 5 | 2.8% | |
| 45 | 4 | 2.2% | |
| 5 | 4 | 2.2% | |
| Other values (24) | 38 | 21.2% |
| Value | Count | Frequency (%) | |
| 1 | 1 | 0.6% | |
| 3 | 1 | 0.6% | |
| 5 | 4 | 2.2% | |
| 6 | 6 | 3.4% | |
| 7 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 273 | 1 | 0.6% | |
| 260 | 1 | 0.6% | |
| 254 | 2 | 1.1% | |
| 227 | 53 | 29.6% | |
| 224 | 3 | 1.7% |
CusCare_flag
Categorical
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 1 |
| Missing (%) | 0.6% |
| Memory size | 1.4 KiB |
| No |
|---|
| Value | Count | Frequency (%) | |
| No | 178 | 99.4% | |
| (Missing) | 1 | 0.6% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 2 |
| Mean length | 2.005586592 |
| Min length | 2 |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 KiB |
| 0 |
|---|
| Value | Count | Frequency (%) | |
| 0 | 179 | 100.0% |
BillCycle_ID
Real number (ℝ≥0)
| Distinct | 10 |
|---|---|
| Distinct (%) | 5.6% |
| Missing | 1 |
| Missing (%) | 0.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.758426966 |
|---|---|
| Minimum | 1 |
| Maximum | 10 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 5 |
| Q3 | 7 |
| 95-th percentile | 9 |
| Maximum | 10 |
| Range | 9 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.556273284 |
|---|---|
| Coefficient of variation (CV) | 0.5372097339 |
| Kurtosis | -0.8169690084 |
| Mean | 4.758426966 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.2379863144 |
| Sum | 847 |
| Variance | 6.534533105 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 5 | 27 | 15.1% | |
| 4 | 24 | 13.4% | |
| 7 | 23 | 12.8% | |
| 1 | 23 | 12.8% | |
| 2 | 19 | 10.6% | |
| 6 | 19 | 10.6% | |
| 3 | 18 | 10.1% | |
| 9 | 12 | 6.7% | |
| 10 | 7 | 3.9% | |
| 8 | 6 | 3.4% | |
| (Missing) | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 1 | 23 | 12.8% | |
| 2 | 19 | 10.6% | |
| 3 | 18 | 10.1% | |
| 4 | 24 | 13.4% | |
| 5 | 27 | 15.1% |
| Value | Count | Frequency (%) | |
| 10 | 7 | 3.9% | |
| 9 | 12 | 6.7% | |
| 8 | 6 | 3.4% | |
| 7 | 23 | 12.8% | |
| 6 | 19 | 10.6% |
| Distinct | 176 |
|---|---|
| Distinct (%) | 99.4% |
| Missing | 2 |
| Missing (%) | 1.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 94.36887006 |
|---|---|
| Minimum | 48.4 |
| Maximum | 213.75 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 48.4 |
|---|---|
| 5-th percentile | 59.486 |
| Q1 | 74.77 |
| median | 91.67 |
| Q3 | 107.03 |
| 95-th percentile | 142.04 |
| Maximum | 213.75 |
| Range | 165.35 |
| Interquartile range (IQR) | 32.26 |
Descriptive statistics
| Standard deviation | 27.46762743 |
|---|---|
| Coefficient of variation (CV) | 0.2910666135 |
| Kurtosis | 3.065647596 |
| Mean | 94.36887006 |
| Median Absolute Deviation (MAD) | 16.5 |
| Skewness | 1.205964951 |
| Sum | 16703.29 |
| Variance | 754.4705567 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 84.48 | 2 | 1.1% | |
| 75.15 | 1 | 0.6% | |
| 100.82 | 1 | 0.6% | |
| 114.75 | 1 | 0.6% | |
| 93.25 | 1 | 0.6% | |
| 141.8 | 1 | 0.6% | |
| 93.92 | 1 | 0.6% | |
| 89.89 | 1 | 0.6% | |
| 110.94 | 1 | 0.6% | |
| 63.15 | 1 | 0.6% | |
| Other values (166) | 166 | 92.7% | |
| (Missing) | 2 | 1.1% |
| Value | Count | Frequency (%) | |
| 48.4 | 1 | 0.6% | |
| 50.07 | 1 | 0.6% | |
| 51.79 | 1 | 0.6% | |
| 51.93 | 1 | 0.6% | |
| 52.28 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 213.75 | 1 | 0.6% | |
| 213.56 | 1 | 0.6% | |
| 174.01 | 1 | 0.6% | |
| 161.73 | 1 | 0.6% | |
| 152.95 | 1 | 0.6% |
| Distinct | 39 |
|---|---|
| Distinct (%) | 21.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.53072626 |
|---|---|
| Minimum | 3 |
| Maximum | 58 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 8 |
| median | 14 |
| Q3 | 23 |
| 95-th percentile | 36 |
| Maximum | 58 |
| Range | 55 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 10.40164772 |
|---|---|
| Coefficient of variation (CV) | 0.6292311396 |
| Kurtosis | 1.435936869 |
| Mean | 16.53072626 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 1.111773414 |
| Sum | 2959 |
| Variance | 108.1942753 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 6 | 14 | 7.8% | |
| 5 | 11 | 6.1% | |
| 11 | 11 | 6.1% | |
| 7 | 10 | 5.6% | |
| 9 | 9 | 5.0% | |
| 12 | 9 | 5.0% | |
| 13 | 8 | 4.5% | |
| 24 | 6 | 3.4% | |
| 10 | 6 | 3.4% | |
| 20 | 6 | 3.4% | |
| Other values (29) | 89 | 49.7% |
| Value | Count | Frequency (%) | |
| 3 | 2 | 1.1% | |
| 4 | 5 | 2.8% | |
| 5 | 11 | 6.1% | |
| 6 | 14 | 7.8% | |
| 7 | 10 | 5.6% |
| Value | Count | Frequency (%) | |
| 58 | 1 | 0.6% | |
| 56 | 1 | 0.6% | |
| 42 | 1 | 0.6% | |
| 40 | 2 | 1.1% | |
| 39 | 1 | 0.6% |
| Distinct | 39 |
|---|---|
| Distinct (%) | 21.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.53072626 |
|---|---|
| Minimum | 3 |
| Maximum | 58 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 8 |
| median | 14 |
| Q3 | 23 |
| 95-th percentile | 36 |
| Maximum | 58 |
| Range | 55 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 10.40164772 |
|---|---|
| Coefficient of variation (CV) | 0.6292311396 |
| Kurtosis | 1.435936869 |
| Mean | 16.53072626 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 1.111773414 |
| Sum | 2959 |
| Variance | 108.1942753 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 6 | 14 | 7.8% | |
| 5 | 11 | 6.1% | |
| 11 | 11 | 6.1% | |
| 7 | 10 | 5.6% | |
| 9 | 9 | 5.0% | |
| 12 | 9 | 5.0% | |
| 13 | 8 | 4.5% | |
| 24 | 6 | 3.4% | |
| 10 | 6 | 3.4% | |
| 20 | 6 | 3.4% | |
| Other values (29) | 89 | 49.7% |
| Value | Count | Frequency (%) | |
| 3 | 2 | 1.1% | |
| 4 | 5 | 2.8% | |
| 5 | 11 | 6.1% | |
| 6 | 14 | 7.8% | |
| 7 | 10 | 5.6% |
| Value | Count | Frequency (%) | |
| 58 | 1 | 0.6% | |
| 56 | 1 | 0.6% | |
| 42 | 1 | 0.6% | |
| 40 | 2 | 1.1% | |
| 39 | 1 | 0.6% |
| Distinct | 31 |
|---|---|
| Distinct (%) | 17.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.687150838 |
|---|---|
| Minimum | 0 |
| Maximum | 36 |
| Zeros | 4 |
| Zeros (%) | 2.2% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 8 |
| Q3 | 13 |
| 95-th percentile | 23.1 |
| Maximum | 36 |
| Range | 36 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 7.481242629 |
|---|---|
| Coefficient of variation (CV) | 0.7722851388 |
| Kurtosis | 2.036852929 |
| Mean | 9.687150838 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 1.408672776 |
| Sum | 1734 |
| Variance | 55.96899127 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 3 | 19 | 10.6% | |
| 4 | 15 | 8.4% | |
| 6 | 14 | 7.8% | |
| 9 | 14 | 7.8% | |
| 5 | 13 | 7.3% | |
| 7 | 11 | 6.1% | |
| 8 | 9 | 5.0% | |
| 10 | 9 | 5.0% | |
| 11 | 8 | 4.5% | |
| 20 | 6 | 3.4% | |
| Other values (21) | 61 | 34.1% |
| Value | Count | Frequency (%) | |
| 0 | 4 | 2.2% | |
| 1 | 6 | 3.4% | |
| 2 | 5 | 2.8% | |
| 3 | 19 | 10.6% | |
| 4 | 15 | 8.4% |
| Value | Count | Frequency (%) | |
| 36 | 1 | 0.6% | |
| 35 | 1 | 0.6% | |
| 34 | 2 | 1.1% | |
| 33 | 1 | 0.6% | |
| 31 | 1 | 0.6% |
Delayed_Partial_Payments
Real number (ℝ≥0)
| Distinct | 25 |
|---|---|
| Distinct (%) | 14.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.843575419 |
|---|---|
| Minimum | 1 |
| Maximum | 55 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 8 |
| 95-th percentile | 22.2 |
| Maximum | 55 |
| Range | 54 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 7.66563179 |
|---|---|
| Coefficient of variation (CV) | 1.12012089 |
| Kurtosis | 11.00628776 |
| Mean | 6.843575419 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 2.867689194 |
| Sum | 1225 |
| Variance | 58.76191074 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 2 | 29 | 16.2% | |
| 3 | 24 | 13.4% | |
| 1 | 22 | 12.3% | |
| 4 | 20 | 11.2% | |
| 5 | 13 | 7.3% | |
| 6 | 12 | 6.7% | |
| 7 | 9 | 5.0% | |
| 10 | 9 | 5.0% | |
| 8 | 7 | 3.9% | |
| 12 | 5 | 2.8% | |
| Other values (15) | 29 | 16.2% |
| Value | Count | Frequency (%) | |
| 1 | 22 | 12.3% | |
| 2 | 29 | 16.2% | |
| 3 | 24 | 13.4% | |
| 4 | 20 | 11.2% | |
| 5 | 13 | 7.3% |
| Value | Count | Frequency (%) | |
| 55 | 1 | 0.6% | |
| 36 | 1 | 0.6% | |
| 35 | 2 | 1.1% | |
| 29 | 1 | 0.6% | |
| 27 | 1 | 0.6% |
| Distinct | 156 |
|---|---|
| Distinct (%) | 87.6% |
| Missing | 1 |
| Missing (%) | 0.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 523.6611236 |
|---|---|
| Minimum | 244.08 |
| Maximum | 1174.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 244.08 |
|---|---|
| 5-th percentile | 304.195 |
| Q1 | 421 |
| median | 500.375 |
| Q3 | 593.375 |
| 95-th percentile | 818.872 |
| Maximum | 1174.5 |
| Range | 930.42 |
| Interquartile range (IQR) | 172.375 |
Descriptive statistics
| Standard deviation | 162.7581175 |
|---|---|
| Coefficient of variation (CV) | 0.3108080975 |
| Kurtosis | 2.853567191 |
| Mean | 523.6611236 |
| Median Absolute Deviation (MAD) | 82 |
| Skewness | 1.318148157 |
| Sum | 93211.68 |
| Variance | 26490.20483 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 402.6 | 5 | 2.8% | |
| 502.5 | 3 | 1.7% | |
| 566.1 | 3 | 1.7% | |
| 432.6 | 3 | 1.7% | |
| 447.43 | 2 | 1.1% | |
| 305.4 | 2 | 1.1% | |
| 500 | 2 | 1.1% | |
| 432 | 2 | 1.1% | |
| 490 | 2 | 1.1% | |
| 647 | 2 | 1.1% | |
| Other values (146) | 152 | 84.9% |
| Value | Count | Frequency (%) | |
| 244.08 | 1 | 0.6% | |
| 255.4 | 1 | 0.6% | |
| 261.05 | 1 | 0.6% | |
| 268.88 | 1 | 0.6% | |
| 277.95 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 1174.5 | 1 | 0.6% | |
| 1164 | 1 | 0.6% | |
| 1044.03 | 1 | 0.6% | |
| 1009 | 1 | 0.6% | |
| 1002 | 1 | 0.6% |
| Distinct | 158 |
|---|---|
| Distinct (%) | 89.8% |
| Missing | 3 |
| Missing (%) | 1.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 91.92340909 |
|---|---|
| Minimum | 42.57 |
| Maximum | 213.75 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 42.57 |
|---|---|
| 5-th percentile | 52.055 |
| Q1 | 71.585 |
| median | 87.405 |
| Q3 | 107.915 |
| 95-th percentile | 144.385 |
| Maximum | 213.75 |
| Range | 171.18 |
| Interquartile range (IQR) | 36.33 |
Descriptive statistics
| Standard deviation | 29.39991518 |
|---|---|
| Coefficient of variation (CV) | 0.3198305575 |
| Kurtosis | 2.486447708 |
| Mean | 91.92340909 |
| Median Absolute Deviation (MAD) | 17.48 |
| Skewness | 1.250733505 |
| Sum | 16178.52 |
| Variance | 864.3550123 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 67.1 | 5 | 2.8% | |
| 83.75 | 3 | 1.7% | |
| 72.1 | 3 | 1.7% | |
| 94.35 | 3 | 1.7% | |
| 72 | 2 | 1.1% | |
| 110 | 2 | 1.1% | |
| 65.13 | 2 | 1.1% | |
| 94.33 | 2 | 1.1% | |
| 110.08 | 2 | 1.1% | |
| 69.75 | 2 | 1.1% | |
| Other values (148) | 150 | 83.8% | |
| (Missing) | 3 | 1.7% |
| Value | Count | Frequency (%) | |
| 42.57 | 1 | 0.6% | |
| 43.51 | 1 | 0.6% | |
| 46.33 | 1 | 0.6% | |
| 47.57 | 1 | 0.6% | |
| 47.6 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 213.75 | 1 | 0.6% | |
| 195.75 | 1 | 0.6% | |
| 194 | 1 | 0.6% | |
| 174.01 | 1 | 0.6% | |
| 168.17 | 1 | 0.6% |
| Distinct | 15 |
|---|---|
| Distinct (%) | 8.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.346368715 |
|---|---|
| Minimum | 3 |
| Maximum | 20 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 5 |
| median | 6 |
| Q3 | 7 |
| 95-th percentile | 12 |
| Maximum | 20 |
| Range | 17 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 2.949504948 |
|---|---|
| Coefficient of variation (CV) | 0.4647547409 |
| Kurtosis | 8.250044488 |
| Mean | 6.346368715 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.575858576 |
| Sum | 1136 |
| Variance | 8.699579436 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 6 | 56 | 31.3% | |
| 5 | 40 | 22.3% | |
| 4 | 23 | 12.8% | |
| 7 | 21 | 11.7% | |
| 3 | 11 | 6.1% | |
| 8 | 7 | 3.9% | |
| 11 | 4 | 2.2% | |
| 9 | 3 | 1.7% | |
| 10 | 3 | 1.7% | |
| 12 | 3 | 1.7% | |
| Other values (5) | 8 | 4.5% |
| Value | Count | Frequency (%) | |
| 3 | 11 | 6.1% | |
| 4 | 23 | 12.8% | |
| 5 | 40 | 22.3% | |
| 6 | 56 | 31.3% | |
| 7 | 21 | 11.7% |
| Value | Count | Frequency (%) | |
| 20 | 3 | 1.7% | |
| 18 | 1 | 0.6% | |
| 15 | 2 | 1.1% | |
| 14 | 1 | 0.6% | |
| 13 | 1 | 0.6% |
| Distinct | 15 |
|---|---|
| Distinct (%) | 8.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.346368715 |
|---|---|
| Minimum | 3 |
| Maximum | 20 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 5 |
| median | 6 |
| Q3 | 7 |
| 95-th percentile | 12 |
| Maximum | 20 |
| Range | 17 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 2.949504948 |
|---|---|
| Coefficient of variation (CV) | 0.4647547409 |
| Kurtosis | 8.250044488 |
| Mean | 6.346368715 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.575858576 |
| Sum | 1136 |
| Variance | 8.699579436 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 6 | 56 | 31.3% | |
| 5 | 40 | 22.3% | |
| 4 | 23 | 12.8% | |
| 7 | 21 | 11.7% | |
| 3 | 11 | 6.1% | |
| 8 | 7 | 3.9% | |
| 11 | 4 | 2.2% | |
| 9 | 3 | 1.7% | |
| 10 | 3 | 1.7% | |
| 12 | 3 | 1.7% | |
| Other values (5) | 8 | 4.5% |
| Value | Count | Frequency (%) | |
| 3 | 11 | 6.1% | |
| 4 | 23 | 12.8% | |
| 5 | 40 | 22.3% | |
| 6 | 56 | 31.3% | |
| 7 | 21 | 11.7% |
| Value | Count | Frequency (%) | |
| 20 | 3 | 1.7% | |
| 18 | 1 | 0.6% | |
| 15 | 2 | 1.1% | |
| 14 | 1 | 0.6% | |
| 13 | 1 | 0.6% |
| Distinct | 8 |
|---|---|
| Distinct (%) | 4.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.955307263 |
|---|---|
| Minimum | 0 |
| Maximum | 7 |
| Zeros | 7 |
| Zeros (%) | 3.9% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 4 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 7 |
| Range | 7 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.627782765 |
|---|---|
| Coefficient of variation (CV) | 0.4115439477 |
| Kurtosis | -0.229093939 |
| Mean | 3.955307263 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -0.5041761163 |
| Sum | 708 |
| Variance | 2.649676731 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 4 | 45 | 25.1% | |
| 6 | 36 | 20.1% | |
| 3 | 35 | 19.6% | |
| 5 | 31 | 17.3% | |
| 2 | 15 | 8.4% | |
| 1 | 8 | 4.5% | |
| 0 | 7 | 3.9% | |
| 7 | 2 | 1.1% |
| Value | Count | Frequency (%) | |
| 0 | 7 | 3.9% | |
| 1 | 8 | 4.5% | |
| 2 | 15 | 8.4% | |
| 3 | 35 | 19.6% | |
| 4 | 45 | 25.1% |
| Value | Count | Frequency (%) | |
| 7 | 2 | 1.1% | |
| 6 | 36 | 20.1% | |
| 5 | 31 | 17.3% | |
| 4 | 45 | 25.1% | |
| 3 | 35 | 19.6% |
| Distinct | 17 |
|---|---|
| Distinct (%) | 9.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.391061453 |
|---|---|
| Minimum | 0 |
| Maximum | 20 |
| Zeros | 61 |
| Zeros (%) | 34.1% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 10 |
| Maximum | 20 |
| Range | 20 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 3.769053243 |
|---|---|
| Coefficient of variation (CV) | 1.576309651 |
| Kurtosis | 8.325083222 |
| Mean | 2.391061453 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.762801811 |
| Sum | 428 |
| Variance | 14.20576235 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 61 | 34.1% | |
| 1 | 39 | 21.8% | |
| 2 | 35 | 19.6% | |
| 3 | 12 | 6.7% | |
| 4 | 8 | 4.5% | |
| 10 | 6 | 3.4% | |
| 5 | 3 | 1.7% | |
| 6 | 3 | 1.7% | |
| 9 | 2 | 1.1% | |
| 8 | 2 | 1.1% | |
| Other values (7) | 8 | 4.5% |
| Value | Count | Frequency (%) | |
| 0 | 61 | 34.1% | |
| 1 | 39 | 21.8% | |
| 2 | 35 | 19.6% | |
| 3 | 12 | 6.7% | |
| 4 | 8 | 4.5% |
| Value | Count | Frequency (%) | |
| 20 | 2 | 1.1% | |
| 19 | 1 | 0.6% | |
| 17 | 1 | 0.6% | |
| 15 | 1 | 0.6% | |
| 14 | 1 | 0.6% |
| Distinct | 177 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 2 |
| Missing (%) | 1.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 150330.8318 |
|---|---|
| Minimum | 5065.09 |
| Maximum | 854484.75 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 5065.09 |
|---|---|
| 5-th percentile | 15604.876 |
| Q1 | 48806.74 |
| median | 107352.28 |
| Q3 | 166583.25 |
| 95-th percentile | 468332.15 |
| Maximum | 854484.75 |
| Range | 849419.66 |
| Interquartile range (IQR) | 117776.51 |
Descriptive statistics
| Standard deviation | 156184.8351 |
|---|---|
| Coefficient of variation (CV) | 1.038940803 |
| Kurtosis | 5.713148828 |
| Mean | 150330.8318 |
| Median Absolute Deviation (MAD) | 59230.97 |
| Skewness | 2.253109386 |
| Sum | 26608557.23 |
| Variance | 2.43937027e+10 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 112647.36 | 1 | 0.6% | |
| 69359.13 | 1 | 0.6% | |
| 134121.62 | 1 | 0.6% | |
| 255797.36 | 1 | 0.6% | |
| 23016.94 | 1 | 0.6% | |
| 168506.2 | 1 | 0.6% | |
| 152169.34 | 1 | 0.6% | |
| 64188.83 | 1 | 0.6% | |
| 102205.13 | 1 | 0.6% | |
| 30479.05 | 1 | 0.6% | |
| Other values (167) | 167 | 93.3% | |
| (Missing) | 2 | 1.1% |
| Value | Count | Frequency (%) | |
| 5065.09 | 1 | 0.6% | |
| 6006.74 | 1 | 0.6% | |
| 8392.14 | 1 | 0.6% | |
| 8543.55 | 1 | 0.6% | |
| 8580.13 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 854484.75 | 1 | 0.6% | |
| 812471.68 | 1 | 0.6% | |
| 744756.2 | 1 | 0.6% | |
| 694534.44 | 1 | 0.6% | |
| 676699.16 | 1 | 0.6% |
| Distinct | 178 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 1 |
| Missing (%) | 0.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13221.78202 |
|---|---|
| Minimum | 1067.94 |
| Maximum | 68781.43 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 1067.94 |
|---|---|
| 5-th percentile | 2011.6 |
| Q1 | 4824.2975 |
| median | 7468.375 |
| Q3 | 16053.7575 |
| 95-th percentile | 44710.36 |
| Maximum | 68781.43 |
| Range | 67713.49 |
| Interquartile range (IQR) | 11229.46 |
Descriptive statistics
| Standard deviation | 13855.97624 |
|---|---|
| Coefficient of variation (CV) | 1.047965865 |
| Kurtosis | 3.470324762 |
| Mean | 13221.78202 |
| Median Absolute Deviation (MAD) | 3954.455 |
| Skewness | 1.940895081 |
| Sum | 2353477.2 |
| Variance | 191988077.5 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 4919.16 | 1 | 0.6% | |
| 3964.47 | 1 | 0.6% | |
| 6327.51 | 1 | 0.6% | |
| 2140.35 | 1 | 0.6% | |
| 17659.49 | 1 | 0.6% | |
| 58598.17 | 1 | 0.6% | |
| 6187.96 | 1 | 0.6% | |
| 7264.9 | 1 | 0.6% | |
| 16047.21 | 1 | 0.6% | |
| 55542.07 | 1 | 0.6% | |
| Other values (168) | 168 | 93.9% |
| Value | Count | Frequency (%) | |
| 1067.94 | 1 | 0.6% | |
| 1198.88 | 1 | 0.6% | |
| 1322.72 | 1 | 0.6% | |
| 1450.86 | 1 | 0.6% | |
| 1451.8 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 68781.43 | 1 | 0.6% | |
| 63139.49 | 1 | 0.6% | |
| 58598.17 | 1 | 0.6% | |
| 58031.57 | 1 | 0.6% | |
| 55542.07 | 1 | 0.6% |
ttl_Data_last6mth
Real number (ℝ≥0)
| Distinct | 178 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 1 |
| Missing (%) | 0.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 491615.1369 |
|---|---|
| Minimum | 1712.4 |
| Maximum | 7031645.78 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 1712.4 |
|---|---|
| 5-th percentile | 7638.4595 |
| Q1 | 21906.96 |
| median | 43028.3 |
| Q3 | 402719.2575 |
| 95-th percentile | 2671788.343 |
| Maximum | 7031645.78 |
| Range | 7029933.38 |
| Interquartile range (IQR) | 380812.2975 |
Descriptive statistics
| Standard deviation | 1010219.936 |
|---|---|
| Coefficient of variation (CV) | 2.054899982 |
| Kurtosis | 12.97505033 |
| Mean | 491615.1369 |
| Median Absolute Deviation (MAD) | 28797.245 |
| Skewness | 3.235905767 |
| Sum | 87507494.36 |
| Variance | 1.020544319e+12 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 19648.54 | 1 | 0.6% | |
| 719167.66 | 1 | 0.6% | |
| 6233.01 | 1 | 0.6% | |
| 10288.77 | 1 | 0.6% | |
| 23417.19 | 1 | 0.6% | |
| 16523.14 | 1 | 0.6% | |
| 1288762.95 | 1 | 0.6% | |
| 42460.06 | 1 | 0.6% | |
| 99271.7 | 1 | 0.6% | |
| 793055.98 | 1 | 0.6% | |
| Other values (168) | 168 | 93.9% |
| Value | Count | Frequency (%) | |
| 1712.4 | 1 | 0.6% | |
| 2264.75 | 1 | 0.6% | |
| 2774.37 | 1 | 0.6% | |
| 3804.54 | 1 | 0.6% | |
| 4412.6 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 7031645.78 | 1 | 0.6% | |
| 4713759 | 1 | 0.6% | |
| 4563988.25 | 1 | 0.6% | |
| 3698790.34 | 1 | 0.6% | |
| 3355329.49 | 1 | 0.6% |
| Distinct | 179 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12284.67034 |
|---|---|
| Minimum | 377.46 |
| Maximum | 58882.16 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 377.46 |
|---|---|
| 5-th percentile | 1383.46 |
| Q1 | 3914.2 |
| median | 7123.5 |
| Q3 | 16601.815 |
| 95-th percentile | 38335.629 |
| Maximum | 58882.16 |
| Range | 58504.7 |
| Interquartile range (IQR) | 12687.615 |
Descriptive statistics
| Standard deviation | 12272.69657 |
|---|---|
| Coefficient of variation (CV) | 0.9990253084 |
| Kurtosis | 2.498878936 |
| Mean | 12284.67034 |
| Median Absolute Deviation (MAD) | 3944.11 |
| Skewness | 1.713735606 |
| Sum | 2198955.99 |
| Variance | 150619081.1 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 3902.41 | 1 | 0.6% | |
| 8245.34 | 1 | 0.6% | |
| 3179.39 | 1 | 0.6% | |
| 7344.42 | 1 | 0.6% | |
| 7952.3 | 1 | 0.6% | |
| 38112.35 | 1 | 0.6% | |
| 41236.17 | 1 | 0.6% | |
| 36262.65 | 1 | 0.6% | |
| 12651.44 | 1 | 0.6% | |
| 21852.56 | 1 | 0.6% | |
| Other values (169) | 169 | 94.4% |
| Value | Count | Frequency (%) | |
| 377.46 | 1 | 0.6% | |
| 634.09 | 1 | 0.6% | |
| 735.43 | 1 | 0.6% | |
| 856.2 | 1 | 0.6% | |
| 1038.83 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 58882.16 | 1 | 0.6% | |
| 54117.73 | 1 | 0.6% | |
| 53270.04 | 1 | 0.6% | |
| 49101.66 | 1 | 0.6% | |
| 48416.99 | 1 | 0.6% |
| Distinct | 179 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.48642797 |
|---|---|
| Minimum | 11.0036187 |
| Maximum | 16.06159477 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 KiB |
Quantile statistics
| Minimum | 11.0036187 |
|---|---|
| 5-th percentile | 11.23457152 |
| Q1 | 11.81351909 |
| median | 12.44995326 |
| Q3 | 12.97033829 |
| 95-th percentile | 14.09849872 |
| Maximum | 16.06159477 |
| Range | 5.05797607 |
| Interquartile range (IQR) | 1.1568192 |
Descriptive statistics
| Standard deviation | 0.9569838625 |
|---|---|
| Coefficient of variation (CV) | 0.07664192389 |
| Kurtosis | 2.625048406 |
| Mean | 12.48642797 |
| Median Absolute Deviation (MAD) | 0.61944895 |
| Skewness | 1.212285173 |
| Sum | 2235.070607 |
| Variance | 0.915818113 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 11.43882946 | 1 | 0.6% | |
| 12.56431545 | 1 | 0.6% | |
| 12.0618229 | 1 | 0.6% | |
| 15.76061693 | 1 | 0.6% | |
| 13.39743695 | 1 | 0.6% | |
| 11.46710112 | 1 | 0.6% | |
| 12.64968608 | 1 | 0.6% | |
| 12.56902331 | 1 | 0.6% | |
| 13.08143149 | 1 | 0.6% | |
| 12.65799164 | 1 | 0.6% | |
| Other values (169) | 169 | 94.4% |
| Value | Count | Frequency (%) | |
| 11.0036187 | 1 | 0.6% | |
| 11.01668918 | 1 | 0.6% | |
| 11.0175446 | 1 | 0.6% | |
| 11.07207412 | 1 | 0.6% | |
| 11.07708478 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 16.06159477 | 1 | 0.6% | |
| 15.98413011 | 1 | 0.6% | |
| 15.93162896 | 1 | 0.6% | |
| 15.76061693 | 1 | 0.6% | |
| 15.12275725 | 1 | 0.6% |
churnid
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 KiB |
| 0 | |
|---|---|
| 1 | 10 |
| Value | Count | Frequency (%) | |
| 0 | 169 | 94.4% | |
| 1 | 10 | 5.6% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| Cust_id | Age | LocID | GenID | RaceID | PkgID | CusCare_flag | Num_calls_Cuscare | BillCycle_ID | Mean_Mthly_Paid | Total_Bills | Num_of_payments | Timely_full_payments | Delayed_Partial_Payments | Total_Paid_last6mth | Mean_Mthly_Paid_last6mth | Total_Bills_last6mth | Num_Payments_last6mth | Timely_Full_Payments_last6mth | Delayed_Partial_Payments_last6mth | ttl_Data | avg_Data | ttl_Data_last6mth | avg_Data_last6mth | avg_online_days | churnid | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 35.0 | 238.0 | 1 | 2 | 227.0 | No | 0 | 6.0 | 89.07 | 22 | 22 | 18 | 4 | 500.75 | 83.46 | 6 | 6 | 6 | 0 | 138033.10 | 7264.90 | 826856.47 | 7253.13 | 13.344052 | 0 |
| 1 | 2 | 27.0 | 242.0 | 2 | 2 | 89.0 | No | 0 | 6.0 | 75.15 | 28 | 28 | 10 | 18 | 400.00 | 66.67 | 6 | 6 | 6 | 0 | 112647.36 | 5928.81 | 38263.82 | 6377.30 | 12.887355 | 0 |
| 2 | 3 | 21.0 | 242.0 | 1 | 1 | 46.0 | No | 0 | 8.0 | 85.57 | 15 | 15 | 9 | 6 | 502.00 | 83.67 | 4 | 4 | 4 | 0 | 263550.68 | 20273.13 | 115426.86 | 19237.81 | 12.345485 | 0 |
| 3 | 4 | 58.0 | 233.0 | 1 | 1 | 227.0 | No | 0 | 6.0 | 102.56 | 11 | 11 | 9 | 2 | 558.90 | 93.15 | 5 | 5 | 5 | 0 | 192596.87 | 14815.14 | 1081668.35 | 13867.54 | 12.649686 | 0 |
| 4 | 5 | 43.0 | 231.0 | 1 | 1 | 227.0 | No | 0 | 9.0 | 102.50 | 11 | 11 | 6 | 5 | 564.00 | 94.00 | 6 | 6 | 4 | 2 | 254325.84 | 23120.53 | 1418866.28 | 21497.97 | 12.633970 | 0 |
| 5 | 6 | 52.0 | 242.0 | 1 | 2 | 222.0 | No | 0 | 2.0 | 174.01 | 6 | 6 | 4 | 2 | 1044.03 | 174.01 | 6 | 6 | 4 | 2 | 127831.15 | 25566.23 | 491679.02 | 19667.16 | 13.436630 | 0 |
| 6 | 7 | 49.0 | 231.0 | 1 | 1 | 227.0 | No | 0 | 9.0 | 102.85 | 13 | 13 | 6 | 7 | 660.00 | 110.00 | 7 | 7 | 3 | 4 | 260268.69 | 21689.06 | 1543001.73 | 21430.58 | 12.144856 | 0 |
| 7 | 8 | 73.0 | 231.0 | 2 | 1 | 6.0 | No | 0 | 4.0 | 79.56 | 21 | 21 | 16 | 5 | 418.50 | 69.75 | 5 | 5 | 5 | 0 | 345424.71 | 15701.12 | 172961.18 | 28826.86 | 12.863905 | 0 |
| 8 | 9 | 31.0 | 237.0 | 1 | 2 | 43.0 | No | 0 | 4.0 | 81.12 | 22 | 22 | 17 | 5 | 498.70 | 83.12 | 7 | 7 | 6 | 1 | 212347.80 | 10617.39 | 88819.68 | 14803.28 | 12.679086 | 0 |
| 9 | 10 | 30.0 | 238.0 | 2 | 1 | 227.0 | No | 0 | 9.0 | 100.71 | 12 | 12 | 6 | 6 | 560.75 | 93.46 | 5 | 5 | 4 | 1 | 143852.43 | 14385.24 | 1012437.08 | 16873.95 | 13.065960 | 0 |
Last rows
| Cust_id | Age | LocID | GenID | RaceID | PkgID | CusCare_flag | Num_calls_Cuscare | BillCycle_ID | Mean_Mthly_Paid | Total_Bills | Num_of_payments | Timely_full_payments | Delayed_Partial_Payments | Total_Paid_last6mth | Mean_Mthly_Paid_last6mth | Total_Bills_last6mth | Num_Payments_last6mth | Timely_Full_Payments_last6mth | Delayed_Partial_Payments_last6mth | ttl_Data | avg_Data | ttl_Data_last6mth | avg_Data_last6mth | avg_online_days | churnid | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 169 | 170 | 43.0 | 234.0 | 2 | 1 | 9.0 | No | 0 | 4.0 | 63.88 | 16 | 16 | 8 | 8 | 417.45 | 69.58 | 7 | 7 | 4 | 3 | NaN | 4863.09 | NaN | 3902.41 | 11.127497 | 0 |
| 170 | 171 | 64.0 | 242.0 | 2 | 4 | 7.0 | No | 0 | 5.0 | 107.14 | 24 | 24 | 17 | 7 | 623.50 | 103.92 | 6 | 6 | 5 | 1 | 166583.25 | 6940.97 | 40679.98 | 6780.00 | 12.663290 | 0 |
| 171 | 172 | 38.0 | 242.0 | 2 | 1 | 168.0 | No | 0 | 8.0 | 61.02 | 5 | 5 | 4 | 1 | 244.08 | 61.02 | 5 | 5 | 4 | 1 | 5065.09 | 1688.36 | 2774.37 | 1387.18 | 12.119770 | 0 |
| 172 | 173 | 29.0 | 232.0 | 1 | 2 | 9.0 | No | 0 | 3.0 | 148.58 | 12 | 12 | 9 | 3 | 812.50 | 135.42 | 5 | 5 | 5 | 0 | 131080.47 | 11916.41 | 75908.64 | 12651.44 | 13.252510 | 0 |
| 173 | 174 | 33.0 | 234.0 | 1 | 2 | 227.0 | No | 0 | 2.0 | 114.75 | 4 | 4 | 3 | 1 | 459.00 | 114.75 | 4 | 4 | 3 | 1 | 75184.91 | 25061.64 | 163757.74 | 18195.30 | 11.016689 | 0 |
| 174 | 175 | 48.0 | 242.0 | 2 | 1 | 216.0 | No | 0 | 7.0 | 128.91 | 11 | 11 | 8 | 3 | 580.00 | 96.67 | 5 | 5 | 5 | 0 | 63906.45 | 7100.72 | 51337.89 | 8556.32 | 12.951210 | 0 |
| 175 | 176 | 47.0 | 244.0 | 1 | 1 | 227.0 | No | 0 | 6.0 | 116.19 | 9 | 9 | 7 | 2 | 660.45 | 110.08 | 7 | 7 | 7 | 0 | 159077.69 | 22725.38 | 833328.31 | 19841.15 | 12.183579 | 0 |
| 176 | 177 | 33.0 | 232.0 | 1 | 1 | 227.0 | No | 0 | 5.0 | 100.08 | 17 | 17 | 4 | 13 | 566.00 | 94.33 | 4 | 4 | 4 | 0 | 281386.14 | 25580.56 | 1288762.95 | 19526.71 | 12.860969 | 0 |
| 177 | 178 | 20.0 | 240.0 | 2 | 4 | 197.0 | No | 0 | 10.0 | 69.85 | 5 | 5 | 3 | 2 | 279.38 | 69.85 | 5 | 5 | 3 | 2 | 22270.12 | 7423.37 | 12100.29 | 6050.15 | 12.709751 | 0 |
| 178 | 179 | 47.0 | 238.0 | 2 | 2 | 5.0 | No | 0 | 4.0 | 52.28 | 27 | 27 | 24 | 3 | 305.40 | 50.90 | 5 | 5 | 4 | 1 | 97336.23 | 3476.29 | 23700.20 | 3950.03 | 11.182745 | 0 |